--------------------------------------------------------

  CREATE TABLE "TB_CM_PROVINCE" 
   (	"ID" int, 
	"REGION_ID" NVARCHAR(2), 
	"NAME" NVARCHAR(50), 
	"LNG"FLOAT, 
	"LAT"FLOAT, 
	"ENTRY_USER_ID" int, 
	"ENTRY_USER_NAME" NVARCHAR(50), 
	"ENTRY_DATE_TIME" DATE, 
	"UPDATE_USER_ID" int, 
	"UPDATE_USER_NAME" NVARCHAR(50), 
	"UPDATE_DATE_TIME" DATE, 
	"SO_TRANSFER_FLAG" NVARCHAR(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_REGION
--------------------------------------------------------

  CREATE TABLE "TB_CM_REGION" 
   (	"ID" NVARCHAR(2), 
	"NAME" NVARCHAR(50), 
	"SO_TRANSFER_FLAG" NVARCHAR(1) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table TB_CM_DISTRICT
--------------------------------------------------------

  CREATE TABLE "TB_CM_DISTRICT" 
   (	"ID" int, 
	"PROVINCE_ID" int, 
	"NAME" NVARCHAR(50), 
	"LNG"FLOAT, 
	"LAT"FLOAT, 
	"ENTRY_USER_ID" int, 
	"ENTRY_USER_NAME" NVARCHAR(50), 
	"ENTRY_DATE_TIME" DATE, 
	"UPDATE_USER_ID" int, 
	"UPDATE_USER_NAME" NVARCHAR(50), 
	"UPDATE_DATE_TIME" DATE
   ) ; 